2016-05-12 - 27113 - Break Fix - ROA121-German Localization #CrystalReportsSupport
BREAK FIX
27113 - ROA121-German Localization
Problem Summary
Need to fix ROA121 report issue in BI production.
Admin Info
Purpose
|
Need to fix ROA121 report issue in BI production.
|
Requested by
|
Christine DiVincenzo
|
Issue Date
|
05-12-2016
|
Resolved by
|
Dhananjay G
|
Resolved Date
|
05-31-2016
|
Document Status
|
Complete
|
Detailed Problem Description
Email from Saravanan on 05/09/2016:
Recap: The infoset (ZSD_CREDIT_OVERVIEW) used for this report is being used by few other reports too and there is an inner join on the language. Instead of removing and messing up other reports, let’s work with abapers and create a new infoset for this report without the join on the language and test whether the data is correct or not.
Issue: The German customers mentioned below seem to have different languages maintained in KNA1VV and TVGRT tables and hence the inner join is not being satisfied and these customers are not being pulled up in the report.
Customers to test:
0001010298
0001010425
0001010616
0001010624
0001010630
0001010709
0001010857
0001010879
0001010890
0001010958
0001010959
0001010975
0001011122
0001011131
0001011168
0001011175
0001011218
So, Create a new infoset, point the report to that infoset and test it.
Solution Analysis and Recommendations
1. Need to create new infoset similar to ZSD_CREDIT_OVERVIEW infoset in NED300.
2. Need to exclude language join between KNA1VV & TVGRT tables in the new infoset.
3. Need to unit test in NED300 and transport it to NEQ100 for further testing.
4. Notify NEC, once it is moved to NEQ and NEP.
5. Need to check & follow NEC standards while modifying the report.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Resolution
1. Created new infoset ZSD_CREDIT_OVERVIEW1 similar to ZSD_CREDIT_OVERVIEW infoset in NED300.
2. Excluded language join between KNA1VV & TVGRT tables in ZSD_CREDIT_OVERVIEW1 infoset.
3. Unit tested in NED300 and transported it to NEQ for further testing.
4. Notified NEC, once it was moved to NEQ and NEP.
5. Placed the report in BI development and informed NEC for promotion after successful validation.
6. Report was successfully promoted to BI Production.
Release Information
2016-05-17 - 27113 - Rel Notes - ROA121-German Localization